The Database API > Database API functions > MMDB.showSPResultsetNamedParams() |
![]() ![]() ![]() |
MMDB.showSPResultsetNamedParams()
Availability
Dreamweaver UltraDev 1.0
Description
Displays a dialog box with the results of executing the specified stored procedure. The dialog box displays a tabular grid, with the header reflecting the column information and data of the result set generated by the executed stored procedure. If the connection string or the stored procedure is invalid, an error appears. You can use this function to verify the validity of the stored procedure. This function differs from MMDB.showSPResultset()
because you can specify the parameter values by name, instead of in the order in which the stored procedure expects them.
Arguments
connName
, procName
, paramNameArray
, paramValuesArray
![]() |
connName is an UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source. |
![]() |
procName is the name of the stored procedure that returns the result set when executed. |
![]() |
paramNameArray is an array containing a list of parameter names. You can use the MMDB.getSPParamsAsString() function to get the parameters of the stored procedure. |
![]() |
paramValuesArray is an array containing a list of design-time parameter test values. |
Returns
Nothing. This function returns an error if the SQL statement is invalid or if the connection string is wrong.
Example
The following code displays the results of the executed stored procedure:
var paramNameArray = new Array("startDate", "salary") var paramValueArray = new Array("2/1/2000", "50000") MMDB.showSPResultsetNamedParams("EmpDB","getNewEmployees¬ MakingAtLeast", paramNameArray, paramValueArray)
![]() ![]() ![]() |